﻿<%@ Page Title="" Language="C#" MasterPageFile="~/teacheryemian/teachermain.Master" AutoEventWireup="true" CodeBehind="teazhusuxuesheng.aspx.cs" Inherits="zlh.teacheryemian.teazhusuxuesheng" %>
<asp:Content ID="Content1" ContentPlaceHolderID="teaContentPlaceHolder1" runat="server">
    <p>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <asp:Label ID="coursename" runat="server" CssClass="word" Text="学号："></asp:Label>
        <asp:TextBox ID="counametxt" runat="server" CssClass="textbox"></asp:TextBox>
        <asp:Button ID="selectname" runat="server" CssClass="button" Text="确认" />
    </p>
    <p>
        &nbsp;</p>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" HorizontalAlign="Center" Width="710px">
        <Columns>
            <asp:BoundField DataField="stuNo" HeaderText="stuNo" SortExpression="stuNo" />
            <asp:BoundField DataField="stuName" HeaderText="stuName" SortExpression="stuName" />
            <asp:BoundField DataField="xiaoqu" HeaderText="xiaoqu" SortExpression="xiaoqu" />
            <asp:BoundField DataField="louhao" HeaderText="louhao" SortExpression="louhao" />
            <asp:BoundField DataField="sushehao" HeaderText="sushehao" SortExpression="sushehao" />
        </Columns>
        <HeaderStyle CssClass="gridxiewHeaderstyle" />
        <RowStyle CssClass="gridviewrowstyle" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112130ConnectionString14 %>" SelectCommand="SELECT * FROM [stuDepartment] WHERE ([stuNo] = @stuNo)">
        <SelectParameters>
            <asp:ControlParameter ControlID="counametxt" Name="stuNo" PropertyName="Text" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>
    <p>
&nbsp;&nbsp;&nbsp;&nbsp;
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:dhd2014112130ConnectionString14 %>" SelectCommand="SELECT * FROM [stuDepartment]">
    </asp:SqlDataSource>
    <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource2" HorizontalAlign="Center" Width="782px">
        <Columns>
            <asp:BoundField DataField="stuNo" HeaderText="stuNo" SortExpression="stuNo" />
            <asp:BoundField DataField="stuName" HeaderText="stuName" SortExpression="stuName" />
            <asp:BoundField DataField="xiaoqu" HeaderText="xiaoqu" SortExpression="xiaoqu" />
            <asp:BoundField DataField="louhao" HeaderText="louhao" SortExpression="louhao" />
            <asp:BoundField DataField="sushehao" HeaderText="sushehao" SortExpression="sushehao" />
        </Columns>
        <HeaderStyle CssClass="gridxiewHeaderstyle" />
        <RowStyle CssClass="gridviewrowstyle" />
    </asp:GridView>
    </p>
    <p>
        &nbsp;</p>
    <br />
    <br />
    <br />
</asp:Content>
